--COUNTRY
INSERT INTO COUNTRY VALUES ('US', 'United States');
INSERT INTO COUNTRY VALUES ('CA', 'Canada');
INSERT INTO COUNTRY VALUES ('AF', 'Afghanistan');
INSERT INTO COUNTRY VALUES ('AL', 'Albania');
INSERT INTO COUNTRY VALUES ('DZ', 'Algeria');
INSERT INTO COUNTRY VALUES ('DS', 'American Samoa');
INSERT INTO COUNTRY VALUES ('AD', 'Andorra');
INSERT INTO COUNTRY VALUES ('AO', 'Angola');
INSERT INTO COUNTRY VALUES ('AI', 'Anguilla');
INSERT INTO COUNTRY VALUES ('AQ', 'Antarctica');
INSERT INTO COUNTRY VALUES ('AG', 'Antigua and/or Barbuda');
INSERT INTO COUNTRY VALUES ('AR', 'Argentina');
INSERT INTO COUNTRY VALUES ('AM', 'Armenia');
INSERT INTO COUNTRY VALUES ('AW', 'Aruba');
INSERT INTO COUNTRY VALUES ('AU', 'Australia');
INSERT INTO COUNTRY VALUES ('AT', 'Austria');
INSERT INTO COUNTRY VALUES ('AZ', 'Azerbaijan');
INSERT INTO COUNTRY VALUES ('BS', 'Bahamas');
INSERT INTO COUNTRY VALUES ('BH', 'Bahrain');
INSERT INTO COUNTRY VALUES ('BD', 'Bangladesh');
INSERT INTO COUNTRY VALUES ('BB', 'Barbados');
INSERT INTO COUNTRY VALUES ('BY', 'Belarus');
INSERT INTO COUNTRY VALUES ('BE', 'Belgium');
INSERT INTO COUNTRY VALUES ('BZ', 'Belize');
INSERT INTO COUNTRY VALUES ('BJ', 'Benin');
INSERT INTO COUNTRY VALUES ('BM', 'Bermuda');
INSERT INTO COUNTRY VALUES ('BT', 'Bhutan');
INSERT INTO COUNTRY VALUES ('BO', 'Bolivia');
INSERT INTO COUNTRY VALUES ('BA', 'Bosnia and Herzegovina');
INSERT INTO COUNTRY VALUES ('BW', 'Botswana');
INSERT INTO COUNTRY VALUES ('BV', 'Bouvet Island');
INSERT INTO COUNTRY VALUES ('BR', 'Brazil');
INSERT INTO COUNTRY VALUES ('IO', 'British lndian Ocean Territory');
INSERT INTO COUNTRY VALUES ('BN', 'Brunei Darussalam');
INSERT INTO COUNTRY VALUES ('BG', 'Bulgaria');
INSERT INTO COUNTRY VALUES ('BF', 'Burkina Faso');
INSERT INTO COUNTRY VALUES ('BI', 'Burundi');
INSERT INTO COUNTRY VALUES ('KH', 'Cambodia');
INSERT INTO COUNTRY VALUES ('CM', 'Cameroon');
INSERT INTO COUNTRY VALUES ('CV', 'Cape Verde');
INSERT INTO COUNTRY VALUES ('KY', 'Cayman Islands');
INSERT INTO COUNTRY VALUES ('CF', 'Central African Republic');
INSERT INTO COUNTRY VALUES ('TD', 'Chad');
INSERT INTO COUNTRY VALUES ('CL', 'Chile');
INSERT INTO COUNTRY VALUES ('CN', 'China');
INSERT INTO COUNTRY VALUES ('CX', 'Christmas Island');
INSERT INTO COUNTRY VALUES ('CC', 'Cocos (Keeling) Islands');
INSERT INTO COUNTRY VALUES ('CO', 'Colombia');
INSERT INTO COUNTRY VALUES ('KM', 'Comoros');
INSERT INTO COUNTRY VALUES ('CG', 'Congo');
INSERT INTO COUNTRY VALUES ('CK', 'Cook Islands');
INSERT INTO COUNTRY VALUES ('CR', 'Costa Rica');
INSERT INTO COUNTRY VALUES ('HR', 'Croatia (Hrvatska)');
INSERT INTO COUNTRY VALUES ('CU', 'Cuba');
INSERT INTO COUNTRY VALUES ('CY', 'Cyprus');
INSERT INTO COUNTRY VALUES ('CZ', 'Czech Republic');
INSERT INTO COUNTRY VALUES ('DK', 'Denmark');
INSERT INTO COUNTRY VALUES ('DJ', 'Djibouti');
INSERT INTO COUNTRY VALUES ('DM', 'Dominica');
INSERT INTO COUNTRY VALUES ('DO', 'Dominican Republic');
INSERT INTO COUNTRY VALUES ('TP', 'East Timor');
INSERT INTO COUNTRY VALUES ('EC', 'Ecuador');
INSERT INTO COUNTRY VALUES ('EG', 'Egypt');
INSERT INTO COUNTRY VALUES ('SV', 'El Salvador');
INSERT INTO COUNTRY VALUES ('GQ', 'Equatorial Guinea');
INSERT INTO COUNTRY VALUES ('ER', 'Eritrea');
INSERT INTO COUNTRY VALUES ('EE', 'Estonia');
INSERT INTO COUNTRY VALUES ('ET', 'Ethiopia');
INSERT INTO COUNTRY VALUES ('FK', 'Falkland Islands (Malvinas)');
INSERT INTO COUNTRY VALUES ('FO', 'Faroe Islands');
INSERT INTO COUNTRY VALUES ('FJ', 'Fiji');
INSERT INTO COUNTRY VALUES ('FI', 'Finland');
INSERT INTO COUNTRY VALUES ('FR', 'France');
INSERT INTO COUNTRY VALUES ('FX', 'France, Metropolitan');
INSERT INTO COUNTRY VALUES ('GF', 'French Guiana');
INSERT INTO COUNTRY VALUES ('PF', 'French Polynesia');
INSERT INTO COUNTRY VALUES ('TF', 'French Southern Territories');
INSERT INTO COUNTRY VALUES ('GA', 'Gabon');
INSERT INTO COUNTRY VALUES ('GM', 'Gambia');
INSERT INTO COUNTRY VALUES ('GE', 'Georgia');
INSERT INTO COUNTRY VALUES ('DE', 'Germany');
INSERT INTO COUNTRY VALUES ('GH', 'Ghana');
INSERT INTO COUNTRY VALUES ('GI', 'Gibraltar');
INSERT INTO COUNTRY VALUES ('GR', 'Greece');
INSERT INTO COUNTRY VALUES ('GL', 'Greenland');
INSERT INTO COUNTRY VALUES ('GD', 'Grenada');
INSERT INTO COUNTRY VALUES ('GP', 'Guadeloupe');
INSERT INTO COUNTRY VALUES ('GU', 'Guam');
INSERT INTO COUNTRY VALUES ('GT', 'Guatemala');
INSERT INTO COUNTRY VALUES ('GN', 'Guinea');
INSERT INTO COUNTRY VALUES ('GW', 'Guinea-Bissau');
INSERT INTO COUNTRY VALUES ('GY', 'Guyana');
INSERT INTO COUNTRY VALUES ('HT', 'Haiti');
INSERT INTO COUNTRY VALUES ('HM', 'Heard and Mc Donald Islands');
INSERT INTO COUNTRY VALUES ('HN', 'Honduras');
INSERT INTO COUNTRY VALUES ('HK', 'Hong Kong');
INSERT INTO COUNTRY VALUES ('HU', 'Hungary');
INSERT INTO COUNTRY VALUES ('IS', 'Iceland');
INSERT INTO COUNTRY VALUES ('IN', 'India');
INSERT INTO COUNTRY VALUES ('ID', 'Indonesia');
INSERT INTO COUNTRY VALUES ('IR', 'Iran (Islamic Republic of)');
INSERT INTO COUNTRY VALUES ('IQ', 'Iraq');
INSERT INTO COUNTRY VALUES ('IE', 'Ireland');
INSERT INTO COUNTRY VALUES ('IL', 'Israel');
INSERT INTO COUNTRY VALUES ('IT', 'Italy');
INSERT INTO COUNTRY VALUES ('CI', 'Ivory Coast');
INSERT INTO COUNTRY VALUES ('JM', 'Jamaica');
INSERT INTO COUNTRY VALUES ('JP', 'Japan');
INSERT INTO COUNTRY VALUES ('JO', 'Jordan');
INSERT INTO COUNTRY VALUES ('KZ', 'Kazakhstan');
INSERT INTO COUNTRY VALUES ('KE', 'Kenya');
INSERT INTO COUNTRY VALUES ('KI', 'Kiribati');
INSERT INTO COUNTRY VALUES ('KP', 'Korea, Democratic People''s Republic of');
INSERT INTO COUNTRY VALUES ('KR', 'Korea, Republic of');
INSERT INTO COUNTRY VALUES ('XK', 'Kosovo');
INSERT INTO COUNTRY VALUES ('KW', 'Kuwait');
INSERT INTO COUNTRY VALUES ('KG', 'Kyrgyzstan');
INSERT INTO COUNTRY VALUES ('LA', 'Lao People''s Democratic Republic');
INSERT INTO COUNTRY VALUES ('LV', 'Latvia');
INSERT INTO COUNTRY VALUES ('LB', 'Lebanon');
INSERT INTO COUNTRY VALUES ('LS', 'Lesotho');
INSERT INTO COUNTRY VALUES ('LR', 'Liberia');
INSERT INTO COUNTRY VALUES ('LY', 'Libyan Arab Jamahiriya');
INSERT INTO COUNTRY VALUES ('LI', 'Liechtenstein');
INSERT INTO COUNTRY VALUES ('LT', 'Lithuania');
INSERT INTO COUNTRY VALUES ('LU', 'Luxembourg');
INSERT INTO COUNTRY VALUES ('MO', 'Macau');
INSERT INTO COUNTRY VALUES ('MK', 'Macedonia');
INSERT INTO COUNTRY VALUES ('MG', 'Madagascar');
INSERT INTO COUNTRY VALUES ('MW', 'Malawi');
INSERT INTO COUNTRY VALUES ('MY', 'Malaysia');
INSERT INTO COUNTRY VALUES ('MV', 'Maldives');
INSERT INTO COUNTRY VALUES ('ML', 'Mali');
INSERT INTO COUNTRY VALUES ('MT', 'Malta');
INSERT INTO COUNTRY VALUES ('MH', 'Marshall Islands');
INSERT INTO COUNTRY VALUES ('MQ', 'Martinique');
INSERT INTO COUNTRY VALUES ('MR', 'Mauritania');
INSERT INTO COUNTRY VALUES ('MU', 'Mauritius');
INSERT INTO COUNTRY VALUES ('TY', 'Mayotte');
INSERT INTO COUNTRY VALUES ('MX', 'Mexico');
INSERT INTO COUNTRY VALUES ('FM', 'Micronesia, Federated States of');
INSERT INTO COUNTRY VALUES ('MD', 'Moldova, Republic of');
INSERT INTO COUNTRY VALUES ('MC', 'Monaco');
INSERT INTO COUNTRY VALUES ('MN', 'Mongolia');
INSERT INTO COUNTRY VALUES ('ME', 'Montenegro');
INSERT INTO COUNTRY VALUES ('MS', 'Montserrat');
INSERT INTO COUNTRY VALUES ('MA', 'Morocco');
INSERT INTO COUNTRY VALUES ('MZ', 'Mozambique');
INSERT INTO COUNTRY VALUES ('MM', 'Myanmar');
INSERT INTO COUNTRY VALUES ('NA', 'Namibia');
INSERT INTO COUNTRY VALUES ('NR', 'Nauru');
INSERT INTO COUNTRY VALUES ('NP', 'Nepal');
INSERT INTO COUNTRY VALUES ('NL', 'Netherlands');
INSERT INTO COUNTRY VALUES ('AN', 'Netherlands Antilles');
INSERT INTO COUNTRY VALUES ('NC', 'New Caledonia');
INSERT INTO COUNTRY VALUES ('NZ', 'New Zealand');
INSERT INTO COUNTRY VALUES ('NI', 'Nicaragua');
INSERT INTO COUNTRY VALUES ('NE', 'Niger');
INSERT INTO COUNTRY VALUES ('NG', 'Nigeria');
INSERT INTO COUNTRY VALUES ('NU', 'Niue');
INSERT INTO COUNTRY VALUES ('NF', 'Norfork Island');
INSERT INTO COUNTRY VALUES ('MP', 'Northern Mariana Islands');
INSERT INTO COUNTRY VALUES ('NO', 'Norway');
INSERT INTO COUNTRY VALUES ('OM', 'Oman');
INSERT INTO COUNTRY VALUES ('PK', 'Pakistan');
INSERT INTO COUNTRY VALUES ('PW', 'Palau');
INSERT INTO COUNTRY VALUES ('PA', 'Panama');
INSERT INTO COUNTRY VALUES ('PG', 'Papua New Guinea');
INSERT INTO COUNTRY VALUES ('PY', 'Paraguay');
INSERT INTO COUNTRY VALUES ('PE', 'Peru');
INSERT INTO COUNTRY VALUES ('PH', 'Philippines');
INSERT INTO COUNTRY VALUES ('PN', 'Pitcairn');
INSERT INTO COUNTRY VALUES ('PL', 'Poland');
INSERT INTO COUNTRY VALUES ('PT', 'Portugal');
INSERT INTO COUNTRY VALUES ('PR', 'Puerto Rico');
INSERT INTO COUNTRY VALUES ('QA', 'Qatar');
INSERT INTO COUNTRY VALUES ('RE', 'Reunion');
INSERT INTO COUNTRY VALUES ('RO', 'Romania');
INSERT INTO COUNTRY VALUES ('RU', 'Russian Federation');
INSERT INTO COUNTRY VALUES ('RW', 'Rwanda');
INSERT INTO COUNTRY VALUES ('KN', 'Saint Kitts and Nevis');
INSERT INTO COUNTRY VALUES ('LC', 'Saint Lucia');
INSERT INTO COUNTRY VALUES ('VC', 'Saint Vincent and the Grenadines');
INSERT INTO COUNTRY VALUES ('WS', 'Samoa');
INSERT INTO COUNTRY VALUES ('SM', 'San Marino');
INSERT INTO COUNTRY VALUES ('ST', 'Sao Tome and Principe');
INSERT INTO COUNTRY VALUES ('SA', 'Saudi Arabia');
INSERT INTO COUNTRY VALUES ('SN', 'Senegal');
INSERT INTO COUNTRY VALUES ('RS', 'Serbia');
INSERT INTO COUNTRY VALUES ('SC', 'Seychelles');
INSERT INTO COUNTRY VALUES ('SL', 'Sierra Leone');
INSERT INTO COUNTRY VALUES ('SG', 'Singapore');
INSERT INTO COUNTRY VALUES ('SK', 'Slovakia');
INSERT INTO COUNTRY VALUES ('SI', 'Slovenia');
INSERT INTO COUNTRY VALUES ('SB', 'Solomon Islands');
INSERT INTO COUNTRY VALUES ('SO', 'Somalia');
INSERT INTO COUNTRY VALUES ('ZA', 'South Africa');
INSERT INTO COUNTRY VALUES ('GS', 'South Georgia South Sandwich Islands');
INSERT INTO COUNTRY VALUES ('ES', 'Spain');
INSERT INTO COUNTRY VALUES ('LK', 'Sri Lanka');
INSERT INTO COUNTRY VALUES ('SH', 'St. Helena');
INSERT INTO COUNTRY VALUES ('PM', 'St. Pierre and Miquelon');
INSERT INTO COUNTRY VALUES ('SD', 'Sudan');
INSERT INTO COUNTRY VALUES ('SR', 'Suriname');
INSERT INTO COUNTRY VALUES ('SJ', 'Svalbarn and Jan Mayen Islands');
INSERT INTO COUNTRY VALUES ('SZ', 'Swaziland');
INSERT INTO COUNTRY VALUES ('SE', 'Sweden');
INSERT INTO COUNTRY VALUES ('CH', 'Switzerland');
INSERT INTO COUNTRY VALUES ('SY', 'Syrian Arab Republic');
INSERT INTO COUNTRY VALUES ('TW', 'Taiwan');
INSERT INTO COUNTRY VALUES ('TJ', 'Tajikistan');
INSERT INTO COUNTRY VALUES ('TZ', 'Tanzania, United Republic of');
INSERT INTO COUNTRY VALUES ('TH', 'Thailand');
INSERT INTO COUNTRY VALUES ('TG', 'Togo');
INSERT INTO COUNTRY VALUES ('TK', 'Tokelau');
INSERT INTO COUNTRY VALUES ('TO', 'Tonga');
INSERT INTO COUNTRY VALUES ('TT', 'Trinidad and Tobago');
INSERT INTO COUNTRY VALUES ('TN', 'Tunisia');
INSERT INTO COUNTRY VALUES ('TR', 'Turkey');
INSERT INTO COUNTRY VALUES ('TM', 'Turkmenistan');
INSERT INTO COUNTRY VALUES ('TC', 'Turks and Caicos Islands');
INSERT INTO COUNTRY VALUES ('TV', 'Tuvalu');
INSERT INTO COUNTRY VALUES ('UG', 'Uganda');
INSERT INTO COUNTRY VALUES ('UA', 'Ukraine');
INSERT INTO COUNTRY VALUES ('AE', 'United Arab Emirates');
INSERT INTO COUNTRY VALUES ('GB', 'United Kingdom');
INSERT INTO COUNTRY VALUES ('UM', 'United States minor outlying islands');
INSERT INTO COUNTRY VALUES ('UY', 'Uruguay');
INSERT INTO COUNTRY VALUES ('UZ', 'Uzbekistan');
INSERT INTO COUNTRY VALUES ('VU', 'Vanuatu');
INSERT INTO COUNTRY VALUES ('VA', 'Vatican City State');
INSERT INTO COUNTRY VALUES ('VE', 'Venezuela');
INSERT INTO COUNTRY VALUES ('VN', 'Vietnam');
INSERT INTO COUNTRY VALUES ('VG', 'Virgin Islands (British)');
INSERT INTO COUNTRY VALUES ('VI', 'Virgin Islands (U.S.)');
INSERT INTO COUNTRY VALUES ('WF', 'Wallis and Futuna Islands');
INSERT INTO COUNTRY VALUES ('EH', 'Western Sahara');
INSERT INTO COUNTRY VALUES ('YE', 'Yemen');
INSERT INTO COUNTRY VALUES ('YU', 'Yugoslavia');
INSERT INTO COUNTRY VALUES ('ZR', 'Zaire');
INSERT INTO COUNTRY VALUES ('ZM', 'Zambia');
INSERT INTO COUNTRY VALUES ('ZW', 'Zimbabwe');

--STATE_PROVINCE
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Tokyo Prefecture', 'JP');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Texas', 'US');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'California', 'US');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'New Jersey', 'US');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Washington', 'US');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Ontario', 'CA');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Yukon', 'CA');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Maharashtra', 'IN');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'New South Wales', 'AU');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Oxford', 'GB');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Manchester', 'GB');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Bavaria', 'DE');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Sao Paulo', 'BR');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Geneve', 'CH');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Utrecht', 'NL');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Distrito Federal', 'MX');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Odessa', 'UA');
INSERT INTO STATE_PROVINCE VALUES (STATE_ID.NEXTVAL, 'Kiev', 'UA');

--CITY
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Tokyo', 0);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Southlake', 1);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'South San Francisco', 2);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'South Brunswick', 3);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Seattle', 4);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Toronto', 5);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Yukon', 6);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Bombay', 7);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Sydney', 8);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Oxford', 9);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Stretford', 10);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Munich', 11);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Sao Paulo', 12);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Geneve', 13);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Utrecht', 14);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Mexico City', 15);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Odessa', 16);
INSERT INTO CITY VALUES (CITY_ID.NEXTVAL, 'Kiev', 17);

--PERMISSION
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'show_user_info');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'edit_user_info');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'add_user');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'del_user');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'add_order');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'edit_order_info');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'del_order');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'add_department');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'del_department');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'add_city');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'del_city');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'add_country');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'del_country');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'show_trans_price');
INSERT INTO PERMISSION VALUES(PERM_ID.NEXTVAL, 'load_trans_price');


--ROLE
INSERT INTO ROLE VALUES(ROLE_ID.NEXTVAL, 'admin');
INSERT INTO ROLE VALUES(ROLE_ID.NEXTVAL, 'operator');
INSERT INTO ROLE VALUES(ROLE_ID.NEXTVAL, 'user');
INSERT INTO ROLE VALUES(ROLE_ID.NEXTVAL, 'trans_company');

--ROLE_PERMISSION
INSERT INTO ROLE_PERMISSION VALUES(0, 0);
INSERT INTO ROLE_PERMISSION VALUES(0, 1);
INSERT INTO ROLE_PERMISSION VALUES(0, 2);
INSERT INTO ROLE_PERMISSION VALUES(0, 3);
INSERT INTO ROLE_PERMISSION VALUES(0, 4);
INSERT INTO ROLE_PERMISSION VALUES(0, 5);
INSERT INTO ROLE_PERMISSION VALUES(0, 6);
INSERT INTO ROLE_PERMISSION VALUES(0, 7);
INSERT INTO ROLE_PERMISSION VALUES(0, 8);
INSERT INTO ROLE_PERMISSION VALUES(0, 9);
INSERT INTO ROLE_PERMISSION VALUES(0, 10);
INSERT INTO ROLE_PERMISSION VALUES(0, 11);
INSERT INTO ROLE_PERMISSION VALUES(0, 12);
INSERT INTO ROLE_PERMISSION VALUES(0, 13);

INSERT INTO ROLE_PERMISSION VALUES(1, 0);
INSERT INTO ROLE_PERMISSION VALUES(1, 1);
INSERT INTO ROLE_PERMISSION VALUES(1, 2);
INSERT INTO ROLE_PERMISSION VALUES(1, 4);
INSERT INTO ROLE_PERMISSION VALUES(1, 5);
INSERT INTO ROLE_PERMISSION VALUES(1, 6);
INSERT INTO ROLE_PERMISSION VALUES(1, 13);

INSERT INTO ROLE_PERMISSION VALUES(3, 14);

--USER
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik1.dan@gmail.com', 0);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik2.dan@gmail.com', 0);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik3.dan@gmail.com', 0);

INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik4.dan@gmail.com', 1);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik5.dan@gmail.com', 1);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik6.dan@gmail.com', 1);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik7.dan@gmail.com', 1);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik8.dan@gmail.com', 1);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik9.dan@gmail.com', 1);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik10.dan@gmail.com', 1);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'miroshnik11.dan@gmail.com', 1);

INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user1@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user2@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user3@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user4@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user5@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user6@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user7@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user8@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user9@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user10@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user11@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user12@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user13@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user14@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'user15@gmail.com', 2);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'scelerisque.lorem@nisiMauris.org',2); 
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'lorem@Quisque.co.uk',2); 
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'luctus.vulputate@sapienNunc.org',2); 
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'sollicitudin@Maurisutquam.org',2); 
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'mauris@quispedePraesent.ca',2); 
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'consequat.purus@pede.com',2); 
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'pharetra@hymenaeos.edu',2); 
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'vel@veliteu.edu',2); 
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'sodales.Mauris@fringilla.co.uk',2); 
INSERT INTO USERS VALUES(USER_ID.NEXTVAL,'id.sapien.Cras@nisi.edu',2);

INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'trans1@gmail.com', 3);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'trans2@gmail.com', 3);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'trans3@gmail.com', 3);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'trans4@gmail.com', 3);
INSERT INTO USERS VALUES(USER_ID.NEXTVAL, 'trans5@gmail.com', 3);

INSERT INTO NATURAL_PERSON VALUES(0, 'Miroshnichenko Daniel', '380936108404');
INSERT INTO NATURAL_PERSON VALUES(1, 'Rogovsky Stanislav', '380936108400');
INSERT INTO NATURAL_PERSON VALUES(2, 'Nataly Grigorenko', '380636108401');

INSERT INTO NATURAL_PERSON VALUES(3, 'Neena Kochhar', '5151234568');
INSERT INTO NATURAL_PERSON VALUES(4, 'Lex De Haan', '5151234567');
INSERT INTO NATURAL_PERSON VALUES(5, 'Alexander Hunold', '5151234566');
INSERT INTO NATURAL_PERSON VALUES(6, 'Bruce Ernst', '5151234565');
INSERT INTO NATURAL_PERSON VALUES(7, 'David Austin', '5151234564');
INSERT INTO NATURAL_PERSON VALUES(8, 'Valli Pataballa', '5151234563');
INSERT INTO NATURAL_PERSON VALUES(9, 'Diana Lorentz', '5151234562');
INSERT INTO NATURAL_PERSON VALUES(10, 'Nancy Greenberg', '5151234561');

INSERT INTO NATURAL_PERSON VALUES(11, 'Daniel Faviet', '5151234560');
INSERT INTO NATURAL_PERSON VALUES(12, 'John Chen', '5151234511');
INSERT INTO NATURAL_PERSON VALUES(13, 'Ismael Sciarra', '5151234521');
INSERT INTO NATURAL_PERSON VALUES(14, 'Jose Manuel Urman', '5151234531');
INSERT INTO NATURAL_PERSON VALUES(15, 'Luis Popp', '5151234541');
INSERT INTO NATURAL_PERSON VALUES(16, 'Den Raphaely', '5151234551');
INSERT INTO NATURAL_PERSON VALUES(17, 'Alexander Khoo', '5151234571');
INSERT INTO NATURAL_PERSON VALUES(18, 'Shelli Baida', '5151234581');
INSERT INTO NATURAL_PERSON VALUES(19, 'Sigal Tobias', '5151234591');

INSERT INTO LEGAL_PERSON VALUES(20, 'Netcracker');
INSERT INTO LEGAL_PERSON VALUES(21, 'DataArt');
INSERT INTO LEGAL_PERSON VALUES(22, 'Ciklum');
INSERT INTO LEGAL_PERSON VALUES(23, 'Luxoft');
INSERT INTO LEGAL_PERSON VALUES(24, 'Sigma');
INSERT INTO LEGAL_PERSON VALUES(25, 'Provectus');

INSERT INTO LEGAL_PERSON VALUES(26, 'trans_company_1');
INSERT INTO LEGAL_PERSON VALUES(27, 'trans_company_2');
INSERT INTO LEGAL_PERSON VALUES(28, 'trans_company_3');
INSERT INTO LEGAL_PERSON VALUES(29, 'trans_company_4');
INSERT INTO LEGAL_PERSON VALUES(30, 'trans_company_5');

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Karen Colmenares', 
	'1244244560', 
	'contact_nc_1@nc.com', 
	20
);
INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Matthew Weiss', 
	'0101271263', 
	'contact_nc2@nc.com', 
	20
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Adam Fripp', 
	'1230271562', 
	'contact_da2@da.com', 
	21
);
INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Payam Kaufling', 
	'1231111563', 
	'contact_da1@da.com', 
	21
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Shanta Vollman', 
	'1221273064', 
	'contact_cl2@cl.com', 
	22
);
INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Kevin Mourgos', 
	'1234275565', 
	'contact_cl1@cl.com', 
	22
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Julia Nayer', 
	'5231474516', 
	'contact_lt2@lt.com', 
	23
);
INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Irene Mikkilineni', 
	'1932074564', 
	'contact_lt1@lt.com', 
	23
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'James Landry',
	'9231174168',  
	'contact_sig2@sig.com', 
	24
);
INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Steven Markle', 
	'1231174460', 
	'contact_sig1@sig.com', 
	24
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Laura Bissot',
	'1034474810',  
	'contact_pv2@pv.com', 
	25
);
INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Mozhe Atkinson', 
	'1221504125', 
	'contact_pv1@pv.com', 
	25
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Mozhe Bissot', 
	'52312758115', 
	'contact_tc_1@trans_company_1.com', 
	26
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'James Marlow', 
	'4234474125', 
	'contact_tc_2@trans_company_2.com',
	27
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'TJ Olson', 
	'3281674525', 
	'contact_tc_3@trans_company_3.com',
	28
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Jason Mallin', 
	'2131273125', 
	'contact_tc_4@trans_company_4.com',
	29
);

INSERT INTO CONTACT_NAME VALUES (
	CONTACT_ID.NEXTVAL, 
	'Michael Rogers', 
	'1221244165', 
	'contact_tc_5@trans_company_5.com',
	30
);

--ORDER_STATUS
INSERT INTO ORDER_STATUS VALUES (ORDER_STATUS_ID.NEXTVAL, 'new');
INSERT INTO ORDER_STATUS VALUES (ORDER_STATUS_ID.NEXTVAL, 'confirmed');
INSERT INTO ORDER_STATUS VALUES (ORDER_STATUS_ID.NEXTVAL, 'process');
INSERT INTO ORDER_STATUS VALUES (ORDER_STATUS_ID.NEXTVAL, 'canceled');
INSERT INTO ORDER_STATUS VALUES (ORDER_STATUS_ID.NEXTVAL, 'finished');

--DEPT_STATUS
INSERT INTO DEPT_STATUS VALUES(DEPT_STATUS_ID.NEXTVAL, 'wait');
INSERT INTO DEPT_STATUS VALUES(DEPT_STATUS_ID.NEXTVAL, 'received');
INSERT INTO DEPT_STATUS VALUES(DEPT_STATUS_ID.NEXTVAL, 'sent');

--DEPARTMENTS
INSERT INTO DEPARTMENT VALUES(DEPT_ID.NEXTVAL, 'OD_TEST_ADDRESS1', 65074, 16);
INSERT INTO DEPARTMENT VALUES(DEPT_ID.NEXTVAL, 'OD_TEST_ADDRESS2', 65075, 16);
INSERT INTO DEPARTMENT VALUES(DEPT_ID.NEXTVAL, 'OD_TEST_ADDRESS3', 65075, 16);

INSERT INTO DEPARTMENT VALUES(DEPT_ID.NEXTVAL, 'KIEV_TEST_ADDR1', 65076, 17);
INSERT INTO DEPARTMENT VALUES(DEPT_ID.NEXTVAL, 'KIEV_TEST_ADDR2', 65077, 17);
INSERT INTO DEPARTMENT VALUES(DEPT_ID.NEXTVAL, 'KIEV_TEST_ADDR3', 65077, 17);

--CURRENCY
INSERT INTO CURRENCY VALUES ('$');
INSERT INTO CURRENCY VALUES ('₴');

--ROADMAP
INSERT INTO ROADMAP VALUES(
	ROADMAP_ID.NEXTVAL,
	0,
	3,
	100,
	0.4,
	SYSDATE,
	9.2,
	30
);
INSERT INTO ROADMAP VALUES(
	ROADMAP_ID.NEXTVAL,
	0,
	1,
	100,
	0.4,
	SYSDATE,
	9.2,
	30
);
INSERT INTO ROADMAP VALUES(
	ROADMAP_ID.NEXTVAL,
	0,
	2,
	100,
	0.4,
	SYSDATE,
	9.2,
	30
);

--ORDERS
INSERT INTO ORDERS VALUES (
	ORDER_ID.NEXTVAL,
	TO_DATE('02.08.2014', 'DD.MM.YYYY'),
	TO_DATE('07.08.2014', 'DD.MM.YYYY'),
	NULL,
	11,
	12,
	4
);
INSERT INTO ORDERS VALUES (
	ORDER_ID.NEXTVAL,
	TO_DATE('07.09.2014', 'DD.MM.YYYY'),
	TO_DATE('11.09.2014', 'DD.MM.YYYY'),
	NULL,
	11,
	12,
	4
);
INSERT INTO ORDERS VALUES (
	ORDER_ID.NEXTVAL,
	TO_DATE('09.10.2014', 'DD.MM.YYYY'),
	TO_DATE('13.10.2014', 'DD.MM.YYYY'),
	NULL,
	11,
	12,
	4
);
INSERT INTO ORDERS VALUES (
	ORDER_ID.NEXTVAL,
	TO_DATE('20.11.2014', 'DD.MM.YYYY'),
	TO_DATE('28.11.2014', 'DD.MM.YYYY'),
	NULL,
	11,
	12,
	4
);


INSERT INTO ORDERS VALUES (
	ORDER_ID.NEXTVAL,
	TO_DATE('06.05.2014', 'DD.MM.YYYY'),
	TO_DATE('09.05.2014', 'DD.MM.YYYY'),
	NULL,
	12,
	11,
	4
);
INSERT INTO ORDERS VALUES (
	ORDER_ID.NEXTVAL,
	TO_DATE('20.09.2014', 'DD.MM.YYYY'),
	TO_DATE('24.09.2014', 'DD.MM.YYYY'),
	NULL,
	12,
	11,
	4
);
INSERT INTO ORDERS VALUES (
	ORDER_ID.NEXTVAL,
	TO_DATE('27.10.2014', 'DD.MM.YYYY'),
	TO_DATE('30.10.2014', 'DD.MM.YYYY'),
	NULL,
	12,
	11,
	4
);
INSERT INTO ORDERS VALUES (
	ORDER_ID.NEXTVAL,
	TO_DATE('19.11.2014', 'DD.MM.YYYY'),
	TO_DATE('23.11.2014', 'DD.MM.YYYY'),
	NULL,
	12,
	11,
	4
);

--CARGO
INSERT INTO CARGO VALUES (
	CARGO_ID.NEXTVAL,
	'CARGO0_USER1',
	3,
	3,
	3,
	3,
	200,
	'$',
	0
);
INSERT INTO CARGO VALUES (
	CARGO_ID.NEXTVAL,
	'CARGO1_USER1',
	3,
	3,
	3,
	3,
	200,
	'$',
	1
);
INSERT INTO CARGO VALUES (
	CARGO_ID.NEXTVAL,
	'CARGO2_USER1',
	3,
	3,
	3,
	3,
	200,
	'$',
	2
);
INSERT INTO CARGO VALUES (
	CARGO_ID.NEXTVAL,
	'CARGO3_USER1',
	3,
	3,
	3,
	3,
	200,
	'$',
	3
);


INSERT INTO CARGO VALUES (
	CARGO_ID.NEXTVAL,
	'CARGO0_USER2',
	3,
	3,
	3,
	3,
	200,
	'$',
	4
);
INSERT INTO CARGO VALUES (
	CARGO_ID.NEXTVAL,
	'CARGO1_USER2',
	3,
	3,
	3,
	3,
	200,
	'$',
	5
);
INSERT INTO CARGO VALUES (
	CARGO_ID.NEXTVAL,
	'CARGO2_USER2',
	3,
	3,
	3,
	3,
	200,
	'$',
	6
);
INSERT INTO CARGO VALUES (
	CARGO_ID.NEXTVAL,
	'CARGO3_USER2',
	3,
	3,
	3,
	3,
	200,
	'$',
	7
);

--PAYMENT
INSERT INTO PAYMENT VALUES (
	0,
	TO_DATE('02.08.2014', 'DD.MM.YYYY'),
	35,
	'₴'	
);
INSERT INTO PAYMENT VALUES (
	1,
	TO_DATE('07.09.2014', 'DD.MM.YYYY'),
	150,
	'₴'	
);
INSERT INTO PAYMENT VALUES (
	2,
	TO_DATE('29.10.2014', 'DD.MM.YYYY'),
	50,
	'₴'	
);
INSERT INTO PAYMENT VALUES (
	3,
	TO_DATE('29.11.2014', 'DD.MM.YYYY'),
	220,
	'₴'	
);


INSERT INTO PAYMENT VALUES (
	4,
	TO_DATE('06.05.2014', 'DD.MM.YYYY'),
	225,
	'₴'	
);
INSERT INTO PAYMENT VALUES (
	5,
	TO_DATE('29.09.2014', 'DD.MM.YYYY'),
	120,
	'₴'	
);
INSERT INTO PAYMENT VALUES (
	6,
	TO_DATE('27.10.2014', 'DD.MM.YYYY'),
	300,
	'₴'	
);
INSERT INTO PAYMENT VALUES (
	7,
	TO_DATE('19.11.2014', 'DD.MM.YYYY'),
	45,
	'₴'	
);

--ORDER_ROADMAP
INSERT INTO ORDER_ROADMAP VALUES (
	0,
	0,
	0,
	0,
	2,
	SYSDATE,
	SYSDATE
);
INSERT INTO ORDER_ROADMAP VALUES (
	0,
	0,
	3,
	1,
	2,
	NULL,
	SYSDATE
);

INSERT INTO ORDER_ROADMAP VALUES (
	1,
	0,
	0,
	0,
	2,
	SYSDATE,
	SYSDATE
);
INSERT INTO ORDER_ROADMAP VALUES (
	1,
	0,
	3,
	1,
	2,
	NULL,
	SYSDATE
);